SongAlbumRecording
Night and Day Centennial Celebration, A 1228
   "   "1236
   "Move 1664
   "Keely Smith 2414
   "Perfectly Frank 2875
   "Cole Porter Songbook - Anything Goes 2945
   "Billie Holiday on the Net 3797
   "Gay Divorcee, The 4625
   "Reinhardt and Grappelly 4633
   "Ella Sings the Cole Porter Songbook 6998
   "Tell Her You Love Her 10158
   "Artie Shaw 10257
   "Night and Day - The Genius of Charlie Parker 11321
   "Piano Forte 11418
   "Equinox 11682
   "Greatest Hits of Sergio Mendes and Brasil '66 11705

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Night and Day"